﻿CREATE TABLE [dbo].[TimeRemind] (
    [id]             INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [UserName]       VARCHAR (50)    NULL,
    [RemindTitle]    NVARCHAR (50)   NULL,
    [RemindText]     NVARCHAR (1000) NULL,
    [TimeType]       INT             NULL,
    [RemindTime]     DATETIME        NULL,
    [LastRemindTime] DATETIME        NULL,
    [RemindDay]      VARCHAR (50)    NULL,
    [RemindWeekday]  VARCHAR (50)    NULL,
    [RemindMonth]    VARCHAR (200)   NULL,
    [RemindYear]     VARCHAR (50)    NULL,
    [CreateDate]     DATETIME        CONSTRAINT [DF_TimeRemind_CreateDate] DEFAULT (getdate()) NULL,
    CONSTRAINT [PK_TimeRemind] PRIMARY KEY CLUSTERED ([id] ASC)
);

